Agent

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Subject:

Agent

The short name field ("ShortName") should only have one value. The alternate name field ("FullName") should be the one having multiple names...

This is how I would solve it:

Create a NotesView object for the view "($People)". Loop through the view, getting one NotesDocument at a time (use GetFirstDocument/GetNextDocument, NOT GetNthDocument!).

For each document use the GetItemValues method to get the content out of the "FullName" field. You will get all the names back as an array.

You can now loop through the array and check for the presence of "@acme.com" (use Instr for this), and if you find it you replace the value with blank.
Finally you use FullTrim() to remove any blank/empty values and write the array back to the field, using the ReplaceItemValue method.
Don't forget to save the document before you process the next document.

Feedback response number WEBB9F8L9Z created by ~Dan Kikiterobu on 01/10/2014